import os

import openpyxl
import xlrd
def case_excel(rows):
     try:
        file_path = os.path.dirname(__file__)
        excel = os.path.join(file_path,"TestData","case_test.xlsx")
        workbook = openpyxl.load_workbook(excel)
        sheet = workbook.active
        return sheet.cell_value(rows,1),sheet.cell_value(rows,2)
     except Exception as e:
          print("读取文件错误：{e}")